|
|
MySQL and MS SQL Database Synchronization
Šimanovský, Filip ; Grégr, Matěj (referee) ; Trchalík, Roman (advisor)
This thesis describes the synchronization of MySQL and MS SQL databases . It explores and describes differences between these two database servers and further designs and implements alghorithms for their safety and economicaly favourable synchronization . Designed methods are implemented in a console application afterwards . Two case studies are used as an illustrative of its work . The result of this thesis is a manual on how to successfully convert MySQL database to MS SQL database (and vice versa ) and the convert application itself .
|
|
|
Suggestions for changes in the production of a part "revolver trigger"
Jiráček, Jan ; Chladil, Josef (referee) ; Kalivoda, Milan (advisor)
The study deals with production technology of “revolver trigger“. Final assembly is short firearm ALFA Steel and its model series of ALFA-PROJ, Ltd company. Introduction submits an explanation of trigger technology suitability. The following analysis describes current manufacturing process, which has manufacturing inaccuracy problem. Furthermore rootcause of manufacturing inaccuracy was determined and analysis of suggestions for changes (including modifications of technological process) was realized. Based on experiment dimensions were measured on provided samples of suggest production in Technical Control Department. Dimensions of triggers manufactured by current production were verified during the experiment too. Results were compared according to the rejects of production. In the final phase of the study manufacturing labor costs were compared for the one piece of trigger with the new suggested technology.
|
|
|
Design of inspection procedure for selected revolver components
Úlehlová, Eva ; Šrámek, Jan (referee) ; Jankových, Róbert (advisor)
The goal of this master’s thesis was design of the inspection procedure for hammer and trigger of the specific revolver model. Thesis was developed in cooperation with the manufacturer of the revolvers. The theoretical part deals with the MSA methodology, which is used to assess acceptability of measurement systems. The practical part describes the current measurement system and performs gage repeatability and reproducibility study. It was confirmed that the current measurement system requires improvement. Subsequently coordinate systems were designed, based on functional features of the hammer and trigger. Automated optical measurements, based on the coordinate systems, were performed. The results from these measurements were again assessed by the gage R&R study. The analysis confirmed improvement of acceptability of the designed measurement systems. Based on these results, it is recommended to apply suggested procedures in practice. Results and recommendations of this master’s thesis can contribute to develop metrology in the company and improve the existing measurement system.
|
|
|
Signal and data logger
Borsányi, Tamás ; Vyskočil, Pavel (referee) ; Kolouch, Jaromír (advisor)
The goal of this project is to design a signal and data logger, which captures analog and digital signals with very long record time. The device supports multichannel complex triggering, a real-time oscilloscope-like mode and an offline mode for analyzing of previously sampled data. This project contains detailed analysis of the topic, description of hardware and software solutions and used methods. The thesis also contains verification tests and measurements. This device will be mainly used for hardware debugging of microprocessor based applications.
|
|
|
Universal Measurement Station
Šantavý, Marek ; Bartoš, Pavel (referee) ; Šimek, Václav (advisor)
The aim of this thesis is to create data acquisition application. The software module is designed for the industrial panel PC. Power Panel 520 from Bernecker + Reiner and the data acquisition board NI USB-6215 from National Instruments represent the fundamental hardware components for this project. Data acquisition and visualization tasks are controlled by a standalone application made in LabVIEW 2011. OPC, industrial standard in communication, is responsible for mutual interconnection between control (PLC) and data acquisition part. Network shared variables and Apple iPad 2 allow remote surveillance for operator. Finally, the creation of user-friendly interface and integration of technologies from different vendors, are main goals of this project.
|
|
|
Technology in production of handguns
Medůsek, Milan ; Prokop, Jaroslav (referee) ; Osička, Karel (advisor)
The thesis discusses the possibility of a rationalizing of a production of handguns in the conditions of the Česká zbrojovka, a.s. company. In the beginning of the theoretical part, it deals with a familiarization with CZUB, its subsidiaries and a manufacturing portfolio. The following is a division of weapons, a describe of components of firearms and their method of a production. The practical part focuses on the possible rationalization of a production of components of a trigger, a hammer and a magazine catch. After analyzing the current situation in the company, the individual variants of the new technologies are described theoretically first of all. The technological processes for each component at each considered technology are created for these new variants. The following is the calculation of the required values for the final comparison. The final part is the technical-economic evaluation, which compares various technological options among themselves. In the final discussion, the possibility of the individual technologies and their implementation risks in the production process are mentioned.
|
|
|
Website Optimization Proposal for the Organization Based on Google Analytics
Sydorenko, Polina ; Matečná, Mária (referee) ; Luhan, Jan (advisor)
Diplomová práce se zaměřuje na návrh konfigurace nástrojů Google Analytics 4 pro digitální společnost v Brně. Práce je rozdělena do tří hlavních částí. První část zkoumá teoretické základy webové analytiky a jejích nástrojů. Druhá část zahrnuje analýzu aktuálního stavu konfigurace nástrojů pro analýzu webových stránek společnosti a provedení důkladné analýzy výkonnosti webu. Nakonec třetí část představuje návrh řešení odvozený z analýzy současného stavu a požadavků společnosti s aplikací teoretických konceptů probíraných v celé práci.
|
|
|
Support for Predictive Application Autoscaling on Kubernetes Platform
Fridrich, David ; Pavela, Jiří (referee) ; Rogalewicz, Adam (advisor)
The goal of this work is to create a new interface that will allow users to process collected metrics for scaling according to a formula (e.g. average value, mathematical equations, conditional statements) defined by a user. It also allows users to use an external interface for connecting KEDA to a component that defines its own scaling behavior, with which the user can achieve more complex solutions like automated predictive scaling of applications on Kubernetes platform. I solved the selected problems by modifying the KEDA core by implementing a new interface for scaling according to a custom formula with arithmetic and conditional expressions and the ability to connect a custom external remote method for calculating metrics using gRPC technology. The created solution provides a more flexible way to process metrics and also allows user to implement their own methods.
|
|
|
Creation of a data model of a selected agenda of the company's economic information system
SOUKUP, Josef
The objective of this thesis is to analyze a selected business agenda and create a conceptual and physical data model of an information system for this agenda on a selected database system. The first part of the thesis are focused on description of information systems and their classification. Data modeling features and requirements are characterized in this part. Following part presents the selection of a modelling tool for creating a data model based on a multi-criteria evaluation. The conceptual schema is modeled using the selected tool. It captures the necessary entities and their attributes to meet the defined requirements. The purpose of creating data model is capture the agenda of warehouse management of small stonemasonry company in South Bohemia region. Each chapter is focused on different part of creating database such as the conceptual, logical and physical levels. To test the created physical model SQL code is generated and uploaded to the web platform bit.io supporting PostgreSQL.
|
|
| |
guest ::
